﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="AddNewEmployee.aspx.cs" Inherits="HumanResorcesProj.GUI.AddNewEmployee" MasterPageFile="~/GUI/HumanResorcesMasterPage.Master" %>

<asp:Content ID="Content1" runat="server" 
    contentplaceholderid="ContentPlaceHolder1">
    <div dir="rtl" style="height: 650px">
        <div align="center" dir="rtl">
                <asp:Label ID="Label2" runat="server" Text="עמותת עדן" Visible="False"></asp:Label>
                </br>
        </div>
                             <div dir="rtl" style="height: 595px">
                                 <asp:FormView ID="FormView1" runat="server" CellPadding="0" 
                                     DataKeyNames="EmpID" DataSourceID="ObjectDataSource1" DefaultMode="Insert" 
                                     ForeColor="#333333" Width="793px" Height="630px" CaptionAlign="Top" 
                                     oniteminserting="FormView1_ItemInserting">
                                     <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                     <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                                     <EditItemTemplate>
                                         EmpName:
                                         <asp:TextBox ID="EmpNameTextBox" runat="server" Text='<%# Bind("EmpName") %>' />
                                         <br />
                                         EmpFamily:
                                         <asp:TextBox ID="EmpFamilyTextBox" runat="server" 
                                             Text='<%# Bind("EmpFamily") %>' />
                                         <br />
                                         EmpID:
                                         <asp:Label ID="EmpIDLabel1" runat="server" Text='<%# Eval("EmpID") %>' />
                                         <br />
                                         EmpAddress:
                                         <asp:TextBox ID="EmpAddressTextBox" runat="server" 
                                             Text='<%# Bind("EmpAddress") %>' />
                                         <br />
                                         EmpGender:
                                         <asp:TextBox ID="EmpGenderTextBox" runat="server" 
                                             Text='<%# Bind("EmpGender") %>' />
                                         <br />
                                         EmpMaritalStatus:
                                         <asp:TextBox ID="EmpMaritalStatusTextBox" runat="server" 
                                             Text='<%# Bind("EmpMaritalStatus") %>' />
                                         <br />
                                         EmpBirthDate:
                                         <asp:TextBox ID="EmpBirthDateTextBox" runat="server" 
                                             Text='<%# Bind("EmpBirthDate") %>' />
                                         <br />
                                         EmpWorkDate:
                                         <asp:TextBox ID="EmpWorkDateTextBox" runat="server" 
                                             Text='<%# Bind("EmpWorkDate") %>' />
                                         <br />
                                         EmpWorkStatus:
                                         <asp:TextBox ID="EmpWorkStatusTextBox" runat="server" 
                                             Text='<%# Bind("EmpWorkStatus") %>' />
                                         <br />
                                         EmpWorkEndDate:
                                         <asp:TextBox ID="EmpWorkEndDateTextBox" runat="server" 
                                             Text='<%# Bind("EmpWorkEndDate") %>' />
                                         <br />
                                         WorkMobile:
                                         <asp:TextBox ID="WorkMobileTextBox" runat="server" 
                                             Text='<%# Bind("WorkMobile") %>' />
                                         <br />
                                         PersonalMobile:
                                         <asp:TextBox ID="PersonalMobileTextBox" runat="server" 
                                             Text='<%# Bind("PersonalMobile") %>' />
                                         <br />
                                         HomePhone:
                                         <asp:TextBox ID="HomePhoneTextBox" runat="server" 
                                             Text='<%# Bind("HomePhone") %>' />
                                         <br />
                                         EmailAddress1:
                                         <asp:TextBox ID="EmailAddress1TextBox" runat="server" 
                                             Text='<%# Bind("EmailAddress1") %>' />
                                         <br />
                                         EmailAddress2:
                                         <asp:TextBox ID="EmailAddress2TextBox" runat="server" 
                                             Text='<%# Bind("EmailAddress2") %>' />
                                         <br />
                                         Projectkey:
                                         <asp:TextBox ID="ProjectkeyTextBox" runat="server" 
                                             Text='<%# Bind("Projectkey") %>' />
                                         <br />
                                         EmpWorkRol:
                                         <asp:TextBox ID="EmpWorkRolTextBox" runat="server" 
                                             Text='<%# Bind("EmpWorkRol") %>' />
                                         <br />
                                         JobPercentage:
                                         <asp:TextBox ID="JobPercentageTextBox" runat="server" 
                                             Text='<%# Bind("JobPercentage") %>' />
                                         <br />
                                         PoolHour:
                                         <asp:TextBox ID="PoolHourTextBox" runat="server" 
                                             Text='<%# Bind("PoolHour") %>' />
                                         <br />
                                         PoolHourType:
                                         <asp:TextBox ID="PoolHourTypeTextBox" runat="server" 
                                             Text='<%# Bind("PoolHourType") %>' />
                                         <br />
                                         Wage:
                                         <asp:TextBox ID="WageTextBox" runat="server" Text='<%# Bind("Wage") %>' />
                                         <br />
                                         WageMethod:
                                         <asp:TextBox ID="WageMethodTextBox" runat="server" 
                                             Text='<%# Bind("WageMethod") %>' />
                                         <br />
                                         GotPhone:
                                         <asp:CheckBox ID="GotPhoneCheckBox" runat="server" 
                                             Checked='<%# Bind("GotPhone") %>' />
                                         <br />
                                         GotAshel:
                                         <asp:CheckBox ID="GotAshelCheckBox" runat="server" 
                                             Checked='<%# Bind("GotAshel") %>' />
                                         <br />
                                         AdvancedStudy:
                                         <asp:CheckBox ID="AdvancedStudyCheckBox" runat="server" 
                                             Checked='<%# Bind("AdvancedStudy") %>' />
                                         <br />
                                         TravelPayment:
                                         <asp:CheckBox ID="TravelPaymentCheckBox" runat="server" 
                                             Checked='<%# Bind("TravelPayment") %>' />
                                         <br />
                                         EmployeePension:
                                         <asp:TextBox ID="EmployeePensionTextBox" runat="server" 
                                             Text='<%# Bind("EmployeePension") %>' />
                                         <br />
                                         employerPension:
                                         <asp:TextBox ID="employerPensionTextBox" runat="server" 
                                             Text='<%# Bind("employerPension") %>' />
                                         <br />
                                         OffsetExemptions:
                                         <asp:TextBox ID="OffsetExemptionsTextBox" runat="server" 
                                             Text='<%# Bind("OffsetExemptions") %>' />
                                         <br />
                                         ProvidentFund:
                                         <asp:TextBox ID="ProvidentFundTextBox" runat="server" 
                                             Text='<%# Bind("ProvidentFund") %>' />
                                         <br />
                                         SubProj:
                                         <asp:TextBox ID="SubProjTextBox" runat="server" Text='<%# Bind("SubProj") %>' />
                                         <br />
                                         EmpChildNum:
                                         <asp:TextBox ID="EmpChildNumTextBox" runat="server" 
                                             Text='<%# Bind("EmpChildNum") %>' />
                                         <br />
                                         EmpWageContract:
                                         <asp:TextBox ID="EmpWageContractTextBox" runat="server" 
                                             Text='<%# Bind("EmpWageContract") %>' />
                                         <br />
                                         TravelMethodType:
                                         <asp:TextBox ID="TravelMethodTypeTextBox" runat="server" 
                                             Text='<%# Bind("TravelMethodType") %>' />
                                         <br />
                                         GotPhoneDetail:
                                         <asp:TextBox ID="GotPhoneDetailTextBox" runat="server" 
                                             Text='<%# Bind("GotPhoneDetail") %>' />
                                         <br />
                                         GotAshelDetail:
                                         <asp:TextBox ID="GotAshelDetailTextBox" runat="server" 
                                             Text='<%# Bind("GotAshelDetail") %>' />
                                         <br />
                                         AdvancedStudyDetail:
                                         <asp:TextBox ID="AdvancedStudyDetailTextBox" runat="server" 
                                             Text='<%# Bind("AdvancedStudyDetail") %>' />
                                         <br />
                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                                             CommandName="Update" Text="Update" />
                                         &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 
                                             CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                                     </EditItemTemplate>
                                     <InsertItemTemplate>
                                         <table style="width: 775px; height: 591px;" bgcolor="#F0F0F0" dir="rtl">
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; color: #000000; ">
                                                     ת.ז :&nbsp;</td>
                                                 <td style="width: 43px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     &nbsp;<asp:TextBox ID="EmpIDTextBox" runat="server" Text='<%# Bind("EmpID") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                                                         ControlToValidate="EmpIDTextBox" EnableClientScript="False" ToolTip="שדה חובה">?</asp:RequiredFieldValidator>
                                                     <asp:CustomValidator ID="CustomValidator1" runat="server" 
                                                         ControlToValidate="EmpIDTextBox" ErrorMessage="עובד קיים במערכת" 
                                                         onservervalidate="CustomValidator1_ServerValidate" ToolTip="עובד קיים במערכת">!</asp:CustomValidator>
                                                     <asp:CustomValidator ID="ValidIDValidator" runat="server" 
                                                         ControlToValidate="EmpIDTextBox" ErrorMessage="ת.ז לא חוקית" 
                                                         onservervalidate="ValidIDValidator_ServerValidate" ToolTip="ת.ז לא חוקית">!!</asp:CustomValidator>
                                                     <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" 
                                                         ControlToValidate="EmpIDTextBox" ErrorMessage="ת.ז לא נכונה" 
                                                         ToolTip="שדה מספרי" ValidationExpression="\d{9}">?</asp:RegularExpressionValidator>
                                                 </td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp; אחוז משרה:
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     <asp:TextBox ID="JobPercentageTextBox" runat="server" 
                                                         Text='<%# Bind("JobPercentage") %>' />
                                                 </td>
                                                 <td>
                                                     <asp:RangeValidator ID="RangeValidator1" runat="server" 
                                                         ControlToValidate="JobPercentageTextBox" ErrorMessage="מספר" MaximumValue="100" 
                                                         MinimumValue="0" ToolTip="שדה מספרי  0-100" Type="Integer">?</asp:RangeValidator>
                                                 </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px; height: 27px;">
                                                 </td>
                                                 <td style="width: 107px; height: 27px; color: #000000; ">
                                                     שם פרטי :&nbsp;&nbsp;</td>
                                                 <td style="width: 43px; height: 27px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px; height: 27px;">
                                                     <asp:TextBox ID="EmpNameTextBox" runat="server" Text='<%# Bind("EmpName") %>' />
                                                 </td>
                                                 <td style="width: 69px; height: 27px;">
                                                     <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" 
                                                         ControlToValidate="EmpNameTextBox" EnableClientScript="False" 
                                                         ToolTip="שדה חובה">?</asp:RequiredFieldValidator>
                                                 </td>
                                                 <td bgcolor="#009900" style="height: 27px; width: 3px;">
                                                     </td>
                                                 <td style="height: 27px; width: 18px;">
                                                     &nbsp;</td>
                                                 <td style="height: 27px; width: 95px;">
                                                     &nbsp;מאגר שעות:
                                                 </td>
                                                 <td style="height: 27px">
                                                     &nbsp;</td>
                                                 <td style="height: 27px">
                                                     <asp:TextBox ID="PoolHourTextBox" runat="server" 
                                                         Text='<%# Bind("PoolHour") %>' />
                                                 </td>
                                                 <td style="height: 27px">
                                                     <asp:CompareValidator ID="CompareValidator5" runat="server" 
                                                         ControlToValidate="PoolHourTextBox" EnableClientScript="False" 
                                                         ErrorMessage="CompareValidator" Operator="DataTypeCheck" ToolTip="שדה מספרי" 
                                                         Type="Integer">?</asp:CompareValidator>
                                                 </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px; height: 18px;">
                                                     </td>
                                                 <td style="width: 107px; height: 18px; color: #000000;">
                                                     <span style="color: #000000; ">&nbsp;שם משפחה </span>
                                                     <span style="color: #000000">:&nbsp;&nbsp;</span></td>
                                                 <td style="width: 43px; height: 18px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px; height: 18px;">
                                                     <asp:TextBox ID="EmpFamilyTextBox" runat="server" 
                                                         Text='<%# Bind("EmpFamily") %>' />
                                                 </td>
                                                 <td style="width: 69px; height: 18px;">
                                                     <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" 
                                                         ControlToValidate="EmpFamilyTextBox" EnableClientScript="False" 
                                                         ToolTip="שדה חובה">?</asp:RequiredFieldValidator>
                                                     </td>
                                                 <td bgcolor="#009900" style="height: 18px; width: 3px;">
                                                     </td>
                                                 <td style="height: 18px; width: 18px;">
                                                     </td>
                                                 <td style="height: 18px; width: 95px;">
                                                     &nbsp;סוג מאגר שעות :
                                                 </td>
                                                 <td style="height: 18px">
                                                     </td>
                                                 <td style="height: 18px">
                                                     <asp:TextBox ID="PoolHourTypeTextBox" runat="server" 
                                                         Text='<%# Bind("PoolHourType") %>' />
                                                 </td>
                                                 <td style="height: 18px">
                                                     </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                 </td>
                                                 <td style="width: 107px; color: #000000;">
                                                     <span style="color: #000000">כתובת:&nbsp; </span>
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="EmpAddressTextBox" runat="server" 
                                                         Text='<%# Bind("EmpAddress") %>' Width="128px" Height="22px" />
                                                 </td>
                                                 <td style="width: 69px" bgcolor="#F0F0F0">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp;שכר:
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     <asp:TextBox ID="WageTextBox" runat="server" Text='<%# Bind("Wage") %>' />
                                                 </td>
                                                 <td>
                                                     <asp:CompareValidator ID="CompareValidator6" runat="server" 
                                                         ControlToValidate="WageTextBox" EnableClientScript="False" 
                                                         ErrorMessage="CompareValidator" Operator="DataTypeCheck" ToolTip="שדה מספרי" 
                                                         Type="Integer">?</asp:CompareValidator>
                                                 </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; color: #000000;">
                                                     מין העובד:&nbsp;&nbsp;</td>
                                                 <td style="width: 43px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     <asp:DropDownList ID="DropDownList1" runat="server" Height="23px" 
                                                         SelectedValue='<%# Bind("EmpGender") %>' Width="126px">
                                                         <asp:ListItem Value="0">--בחר--</asp:ListItem>
                                                         <asp:ListItem>זכר</asp:ListItem>
                                                         <asp:ListItem>נקבה</asp:ListItem>
                                                     </asp:DropDownList>
                                                 </td>
                                                 <td style="width: 69px">
                                                     <asp:CompareValidator ID="CompareValidator3" runat="server" 
                                                         ControlToValidate="DropDownList1" EnableClientScript="False" 
                                                         ErrorMessage="CompareValidator" Operator="NotEqual" ToolTip="שדה חובה" 
                                                         ValueToCompare="0">?</asp:CompareValidator>
                                                 </td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp;סוג שכר:</td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     <asp:TextBox ID="WageMethodTextBox" runat="server" 
                                                         Text='<%# Bind("WageMethod") %>' />
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px; height: 5px;">
                                                 </td>
                                                 <td style="width: 107px; height: 5px; color: #000000;">
                                                     מצב משפחתי:
                                                 </td>
                                                 <td style="width: 43px; height: 5px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px; height: 5px;">
                                                     <asp:DropDownList ID="DropDownList6" runat="server" Height="23px" 
                                                         SelectedValue='<%# Bind("EmpMaritalStatus") %>'>
                                                          <asp:ListItem Value="0">--בחר--</asp:ListItem>
                                                          <asp:ListItem Value="רווק\ה">רווק\ה</asp:ListItem>
                                                          <asp:ListItem>נשוי\אה</asp:ListItem>
                                                          <asp:ListItem>אלמן\נה</asp:ListItem>
                                                          <asp:ListItem>גרוש\ה</asp:ListItem>
                                                    </asp:DropDownList>
                                                 </td>
                                                 <td style="width: 69px; height: 5px;">
                                                     <asp:CompareValidator ID="CompareValidator4" runat="server" 
                                                         ControlToValidate="DropDownList6" EnableClientScript="False" 
                                                         ErrorMessage="CompareValidator" Operator="NotEqual" ToolTip="שדה חובה" 
                                                         ValueToCompare="0">?</asp:CompareValidator>
                                                     </td>
                                                 <td bgcolor="#009900" style="width: 3px; height: 5px;">
                                                     </td>
                                                 <td style="width: 18px; height: 5px;">
                                                     </td>
                                                 <td style="width: 95px; height: 5px;">
                                                     פנסיית עובד:</td>
                                                 <td style="height: 5px">
                                                     </td>
                                                 <td style="height: 5px">
                                                     <asp:TextBox ID="EmployeePensionTextBox" runat="server" 
                                                         Text='<%# Bind("EmployeePension") %>' />
                                                 </td>
                                                 <td style="height: 5px">
                                                     </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px; height: 4px;">
                                                     </td>
                                                 <td style="width: 107px; height: 4px;">
                                                     </td>
                                                 <td style="width: 43px; height: 4px;">
                                                     </td>
                                                 <td style="height: 4px; font-size: small;" colspan="2">
                                                     &nbsp;<span style="color: #CC6600">( ילדים : במסך&nbsp; עריכה בלבד)</span></td>
                                                 <td bgcolor="#009900" style="width: 3px; height: 4px;">
                                                     </td>
                                                 <td style="width: 18px; height: 4px;">
                                                     </td>
                                                 <td style="width: 95px; height: 4px;">
                                                     פנסיית מעביד :</td>
                                                 <td style="height: 4px">
                                                     </td>
                                                 <td style="height: 4px">
                                                     <asp:TextBox ID="employerPensionTextBox" runat="server" 
                                                         Text='<%# Bind("employerPension") %>' />
                                                 </td>
                                                 <td style="height: 4px">
                                                     </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; color: #000000;">
                                                     תאריך לידה:&nbsp;&nbsp;
                                                 </td>
                                                 <td style="width: 43px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="EmpBirthDateTextBox" runat="server" 
                                                         Text='<%# Bind("EmpBirthDate") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" 
                                                         ControlToValidate="EmpBirthDateTextBox" ErrorMessage="תאריך לא תקין" 
                                                         SetFocusOnError="True" ToolTip="dd/mm/yyyy" 
                                                         ValidationExpression="([0-3][0-9].[0-1][0-9].[1-2][0-9][0-9][0-9])">?</asp:RegularExpressionValidator>
                                                 </td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     פיצויי פיטורים:
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     <asp:TextBox ID="OffsetExemptionsTextBox" runat="server" 
                                                         Text='<%# Bind("OffsetExemptions") %>' />
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; color: #000000;">
                                                     תאריך ההעסקה:
                                                 </td>
                                                 <td style="width: 43px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="EmpWorkDateTextBox" runat="server" 
                                                         Text='<%# Bind("EmpWorkDate") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     <asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server" 
                                                         ControlToValidate="EmpWorkDateTextBox" ErrorMessage="תאריך לא תקין" 
                                                         SetFocusOnError="True" ToolTip="dd/mm/yyyy" 
                                                         ValidationExpression="([0-3][0-9].[0-1][0-9].[1-2][0-9][0-9][0-9])">?</asp:RegularExpressionValidator>
                                                 </td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     קופ&quot;ג :
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     <asp:TextBox ID="ProvidentFundTextBox" runat="server" 
                                                         Text='<%# Bind("ProvidentFund") %>' />
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; ">
                                                     סטטוס עובד :</td>
                                                 <td style="width: 43px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     <asp:DropDownList ID="DropDownList3" runat="server" Height="24px" 
                                                         SelectedValue='<%# Bind("EmpWorkStatus") %>' Width="118px">
                                                         <asp:ListItem Value="0">--בחר--</asp:ListItem>
                                                         <asp:ListItem>פעיל</asp:ListItem>
                                                         <asp:ListItem>לא פעיל</asp:ListItem>
                                                     </asp:DropDownList>
                                                 </td>
                                                 <td style="width: 69px">
                                                     <asp:CompareValidator ID="CompareValidator7" runat="server" 
                                                         ControlToValidate="DropDownList3" EnableClientScript="False" 
                                                         ErrorMessage="CompareValidator" Operator="NotEqual" ToolTip="שדה חובה" 
                                                         ValueToCompare="0">?</asp:CompareValidator>
                                                 </td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     תאריך סיום עבודה :</td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     <asp:TextBox ID="EmpWorkEndDateTextBox" runat="server" 
                                                         Text='<%# Bind("EmpWorkEndDate") %>' />
                                                 </td>
                                                 <td>
                                                     <asp:RegularExpressionValidator ID="RegularExpressionValidator4" runat="server" 
                                                         ControlToValidate="EmpWorkEndDateTextBox" ErrorMessage="תאריך לא תקין" 
                                                         SetFocusOnError="True" ToolTip="dd/mm/yyyy" 
                                                         ValidationExpression="([0-3][0-9].[0-1][0-9].[1-2][0-9][0-9][0-9])">?</asp:RegularExpressionValidator>
                                                 </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px; height: 26px;">
                                                     </td>
                                                 <td style="width: 107px; height: 26px;">
                                                     טלפון חברה:&nbsp;</td>
                                                 <td style="width: 43px; height: 26px;">
                                                     <asp:CheckBox ID="u" runat="server" Checked='<%# Bind("GotPhone") %>' />
                                                 </td>
                                                 <td style="width: 94px; height: 26px;">
                                                     <asp:TextBox ID="GotPhoneDetailTextBox" runat="server" Height="19px" 
                                                         Text='<%# Bind("WorkMobile") %>' Width="130px" />
                                                 </td>
                                                 <td style="width: 69px; height: 26px;">
                                                     </td>
                                                 <td bgcolor="#009900" style="width: 3px; height: 26px;">
                                                     </td>
                                                 <td style="width: 18px; height: 26px;">
                                                     </td>
                                                 <td style="width: 95px; height: 26px;">
                                                     &nbsp;</td>
                                                 <td style="height: 26px">
                                                     </td>
                                                 <td style="height: 26px">
                                                     &nbsp;</td>
                                                 <td dir="rtl" style="height: 26px">
                                                     </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     סוללרי אישי:
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="PersonalMobileTextBox" runat="server" 
                                                         Text='<%# Bind("PersonalMobile") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp;קרן השתלמות: </td>
                                                 <td>
                                                     <asp:CheckBox ID="A" runat="server" Checked='<%# Bind("AdvancedStudy") %>' />
                                                 </td>
                                                 <td>
                                                     <asp:TextBox ID="AdvancedStudyDetailTextBox" runat="server" 
                                                         Text='<%# Bind("AdvancedStudyDetail") %>' />
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     טל&#39; בית:&nbsp;
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="HomePhoneTextBox" runat="server" 
                                                         Text='<%# Bind("HomePhone") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp;אש&quot;ל:
                                                 </td>
                                                 <td>
                                                     <asp:CheckBox ID="G" runat="server" Checked='<%# Bind("GotAshel") %>' />
                                                 </td>
                                                 <td>
                                                     <asp:TextBox ID="GotAshelDetailTextBox" runat="server" 
                                                         Text='<%# Bind("GotAshelDetail") %>' />
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     מייל 1:
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="EmailAddress1TextBox" runat="server" 
                                                         Text='<%# Bind("EmailAddress1") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     החזר נסיעות: &nbsp;</td>
                                                 <td>
                                                     <asp:CheckBox ID="T" runat="server" Checked='<%# Bind("TravelPayment") %>' />
                                                 </td>
                                                 <td>
                                                     <asp:TextBox ID="TravelMethodTypeTextBox" runat="server" 
                                                         Text='<%# Bind("TravelMethodType") %>' />
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     מייל 2:&nbsp;
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="EmailAddress2TextBox" runat="server" 
                                                         Text='<%# Bind("EmailAddress2") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; ">
                                                     פרויקט:&nbsp;
                                                 </td>
                                                 <td style="width: 43px; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     <asp:DropDownList ID="DropDownList8" runat="server" 
                                                         DataSourceID="SqlDataSource2" DataTextField="ProjectName" 
                                                         DataValueField="ProjectName" 
                                                         SelectedValue='<%# Bind("ProjectKey") %>' 
                                                         AutoPostBack="True" Width="124px" 
                                                         onselectedindexchanged="DropDownList8_SelectedIndexChanged">
                                                     </asp:DropDownList>
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td colspan="2">
                                                     <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                                                         ConnectionString="<%$ ConnectionStrings:Eden-DatabaseConnectionString3 %>" 
                                                         
                                                         SelectCommand="SELECT DISTINCT [ProjectName] FROM [AssoDomain] Where AssoName = @AssoName">
                                                         <SelectParameters>
                                                             <asp:ControlParameter ControlID="Label2" Name="AssoName" PropertyName="Text" />
                                                         </SelectParameters>
                                                     </asp:SqlDataSource>
                                                     </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px; ">
                                                     תת-פרויקט:
                                                 </td>
                                                 <td style="width: 43px; colorD: #FF0000; color: #FF0000;">
                                                     *</td>
                                                 <td style="width: 94px">
                                                     <asp:DropDownList ID="DropDownList7" runat="server" 
                                                          Height="22px" Width="124px" DataValueField="SubProj">
                                                     </asp:DropDownList>
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                 </td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td colspan="2">
                                                     <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                                                         ConnectionString="<%$ ConnectionStrings:Eden-DatabaseConnectionString3 %>" 
                                                         SelectCommand="SELECT DISTINCT [SubProj] FROM [AssoDomain]">
                                                     </asp:SqlDataSource>
                                                 </td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     תפקיד:
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:TextBox ID="EmpWorkRolTextBox" runat="server" 
                                                         Text='<%# Bind("EmpWorkRol") %>' />
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td colspan="3" rowspan="2">
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     &nbsp;</td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;&nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                             <tr>
                                                 <td style="width: 8px">
                                                     &nbsp;</td>
                                                 <td style="width: 107px">
                                                     <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                                                         CommandName="Insert" Text="הוסף עובד חדש" onclick="InsertButton_Click" />
                                                 </td>
                                                 <td style="width: 43px">
                                                     &nbsp;</td>
                                                 <td style="width: 94px">
                                                     <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" 
                                                         CommandName="Cancel" Text="בטל" onclick="InsertCancelButton_Click" />
                                                 </td>
                                                 <td style="width: 69px">
                                                     &nbsp;</td>
                                                 <td bgcolor="#009900" style="width: 3px">
                                                     &nbsp;&nbsp;</td>
                                                 <td style="width: 18px">
                                                     &nbsp;</td>
                                                 <td style="width: 95px">
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                                 <td>
                                                     &nbsp;</td>
                                             </tr>
                                         </table>
                                         &nbsp;<br />
                                         &nbsp;
                                     </InsertItemTemplate>
                                     <ItemTemplate>
                                         EmpName:
                                         <asp:Label ID="EmpNameLabel" runat="server" Text='<%# Bind("EmpName") %>' />
                                         <br />
                                         EmpFamily:
                                         <asp:Label ID="EmpFamilyLabel" runat="server" Text='<%# Bind("EmpFamily") %>' />
                                         <br />
                                         EmpID:
                                         <asp:Label ID="EmpIDLabel" runat="server" Text='<%# Eval("EmpID") %>' />
                                         <br />
                                         EmpAddress:
                                         <asp:Label ID="EmpAddressLabel" runat="server" 
                                             Text='<%# Bind("EmpAddress") %>' />
                                         <br />
                                         EmpGender:
                                         <asp:Label ID="EmpGenderLabel" runat="server" Text='<%# Bind("EmpGender") %>' />
                                         <br />
                                         EmpMaritalStatus:
                                         <asp:Label ID="EmpMaritalStatusLabel" runat="server" 
                                             Text='<%# Bind("EmpMaritalStatus") %>' />
                                         <br />
                                         EmpBirthDate:
                                         <asp:Label ID="EmpBirthDateLabel" runat="server" 
                                             Text='<%# Bind("EmpBirthDate") %>' />
                                         <br />
                                         EmpWorkDate:
                                         <asp:Label ID="EmpWorkDateLabel" runat="server" 
                                             Text='<%# Bind("EmpWorkDate") %>' />
                                         <br />
                                         EmpWorkStatus:&nbsp;&nbsp;&nbsp;&nbsp;
                                         <asp:Label ID="EmpWorkStatusLabel" runat="server" 
                                             Text='<%# Bind("EmpWorkStatus") %>' />
                                         <br />
                                         EmpWorkEndDate:
                                         <asp:Label ID="EmpWorkEndDateLabel" runat="server" 
                                             Text='<%# Bind("EmpWorkEndDate") %>' />
                                         <br />
                                         WorkMobile:
                                         <asp:Label ID="WorkMobileLabel" runat="server" 
                                             Text='<%# Bind("WorkMobile") %>' />
                                         <br />
                                         PersonalMobile:
                                         <asp:Label ID="PersonalMobileLabel" runat="server" 
                                             Text='<%# Bind("PersonalMobile") %>' />
                                         <br />
                                         HomePhone:
                                         <asp:Label ID="HomePhoneLabel" runat="server" Text='<%# Bind("HomePhone") %>' />
                                         <br />
                                         EmailAddress1:
                                         <asp:Label ID="EmailAddress1Label" runat="server" 
                                             Text='<%# Bind("EmailAddress1") %>' />
                                         <br />
                                         EmailAddress2:
                                         <asp:Label ID="EmailAddress2Label" runat="server" 
                                             Text='<%# Bind("EmailAddress2") %>' />
                                         <br />
                                         Projectkey:
                                         <asp:Label ID="ProjectkeyLabel" runat="server" 
                                             Text='<%# Bind("Projectkey") %>' />
                                         <br />
                                         EmpWorkRol:
                                         <asp:Label ID="EmpWorkRolLabel" runat="server" 
                                             Text='<%# Bind("EmpWorkRol") %>' />
                                         <br />
                                         JobPercentage:
                                         <asp:Label ID="JobPercentageLabel" runat="server" 
                                             Text='<%# Bind("JobPercentage") %>' />
                                         <br />
                                         PoolHour:
                                         <asp:Label ID="PoolHourLabel" runat="server" Text='<%# Bind("PoolHour") %>' />
                                         <br />
                                         PoolHourType:
                                         <asp:Label ID="PoolHourTypeLabel" runat="server" 
                                             Text='<%# Bind("PoolHourType") %>' />
                                         <br />
                                         Wage:
                                         <asp:Label ID="WageLabel" runat="server" Text='<%# Bind("Wage") %>' />
                                         <br />
                                         WageMethod:
                                         <asp:Label ID="WageMethodLabel" runat="server" 
                                             Text='<%# Bind("WageMethod") %>' />
                                         <br />
                                         GotPhone:
                                         <asp:CheckBox ID="GotPhoneCheckBox" runat="server" 
                                             Checked='<%# Bind("GotPhone") %>' Enabled="false" />
                                         <br />
                                         GotAshel:
                                         <asp:CheckBox ID="GotAshelCheckBox" runat="server" 
                                             Checked='<%# Bind("GotAshel") %>' Enabled="false" />
                                         <br />
                                         AdvancedStudy:
                                         <asp:CheckBox ID="AdvancedStudyCheckBox" runat="server" 
                                             Checked='<%# Bind("AdvancedStudy") %>' Enabled="false" />
                                         <br />
                                         TravelPayment:
                                         <asp:CheckBox ID="TravelPaymentCheckBox" runat="server" 
                                             Checked='<%# Bind("TravelPayment") %>' Enabled="false" />
                                         <br />
                                         EmployeePension:
                                         <asp:Label ID="EmployeePensionLabel" runat="server" 
                                             Text='<%# Bind("EmployeePension") %>' />
                                         <br />
                                         employerPension:
                                         <asp:Label ID="employerPensionLabel" runat="server" 
                                             Text='<%# Bind("employerPension") %>' />
                                         <br />
                                         OffsetExemptions:
                                         <asp:Label ID="OffsetExemptionsLabel" runat="server" 
                                             Text='<%# Bind("OffsetExemptions") %>' />
                                         <br />
                                         ProvidentFund:
                                         <asp:Label ID="ProvidentFundLabel" runat="server" 
                                             Text='<%# Bind("ProvidentFund") %>' />
                                         <br />
                                         SubProj:
                                         <asp:Label ID="SubProjLabel" runat="server" Text='<%# Bind("SubProj") %>' />
                                         <br />
                                         EmpChildNum:
                                         <asp:Label ID="EmpChildNumLabel" runat="server" 
                                             Text='<%# Bind("EmpChildNum") %>' />
                                         <br />
                                         EmpWageContract:
                                         <asp:Label ID="EmpWageContractLabel" runat="server" 
                                             Text='<%# Bind("EmpWageContract") %>' />
                                         <br />
                                         TravelMethodType:
                                         <asp:Label ID="TravelMethodTypeLabel" runat="server" 
                                             Text='<%# Bind("TravelMethodType") %>' />
                                         <br />
                                         GotPhoneDetail:
                                         <asp:Label ID="GotPhoneDetailLabel" runat="server" 
                                             Text='<%# Bind("GotPhoneDetail") %>' />
                                         <br />
                                         GotAshelDetail:
                                         <asp:Label ID="GotAshelDetailLabel" runat="server" 
                                             Text='<%# Bind("GotAshelDetail") %>' />
                                         <br />
                                         AdvancedStudyDetail:
                                         <asp:Label ID="AdvancedStudyDetailLabel" runat="server" 
                                             Text='<%# Bind("AdvancedStudyDetail") %>' />
                                         <br />
                                         <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" 
                                             CommandName="Edit" Text="Edit" />
                                         &nbsp;<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" 
                                             CommandName="Delete" Text="Delete" />
                                         &nbsp;<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" 
                                             CommandName="New" Text="New" />
                                     </ItemTemplate>
                                     <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                                     <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                     <InsertRowStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                                     <EditRowStyle BackColor="White" />
                                 </asp:FormView>
                                 <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
                                     InsertMethod="InsertNewEmp" SelectMethod="getData" 
                                     TypeName="HumanResorcesProj.BLL.Emp">
                                     <InsertParameters>
                                         <asp:Parameter Name="EmpName" Type="String" />
                                         <asp:Parameter Name="EmpFamily" Type="String" />
                                         <asp:Parameter Name="EmpID" Type="String" />
                                         <asp:Parameter Name="EmpAddress" Type="String" />
                                         <asp:Parameter Name="EmpGender" Type="String" />
                                         <asp:Parameter Name="EmpMaritalStatus" Type="String" />
                                         <asp:Parameter Name="EmpBirthDate" Type="String" />
                                         <asp:Parameter Name="EmpWorkDate" Type="String" />
                                         <asp:Parameter Name="EmpWorkStatus" Type="String" />
                                         <asp:Parameter Name="EmpWorkEndDate" Type="String" />
                                         <asp:Parameter Name="WorkMobile" Type="String" />
                                         <asp:Parameter Name="PersonalMobile" Type="String" />
                                         <asp:Parameter Name="HomePhone" Type="String" />
                                         <asp:Parameter Name="EmailAddress1" Type="String" />
                                         <asp:Parameter Name="EmailAddress2" Type="String" />
                                         <asp:Parameter Name="Projectkey" Type="String" />
                                         <asp:Parameter Name="EmpWorkRol" Type="String" />
                                         <asp:Parameter Name="JobPercentage" Type="String" />
                                         <asp:Parameter Name="PoolHour" Type="String" />
                                         <asp:Parameter Name="PoolHourType" Type="String" />
                                         <asp:Parameter Name="Wage" Type="String" />
                                         <asp:Parameter Name="WageMethod" Type="String" />
                                         <asp:Parameter Name="GotPhone" Type="Boolean" />
                                         <asp:Parameter Name="GotAshel" Type="Boolean" />
                                         <asp:Parameter Name="AdvancedStudy" Type="Boolean" />
                                         <asp:Parameter Name="TravelPayment" Type="Boolean" />
                                         <asp:Parameter Name="EmployeePension" Type="String" />
                                         <asp:Parameter Name="employerPension" Type="String" />
                                         <asp:Parameter Name="OffsetExemptions" Type="String" />
                                         <asp:Parameter Name="ProvidentFund" Type="String" />
                                         <asp:Parameter Name="SubProj" Type="String" />
                                         <asp:Parameter Name="EmpChildNum" Type="String" />
                                         <asp:Parameter Name="EmpWageContract" Type="String" />
                                         <asp:Parameter Name="TravelMethodType" Type="String" />
                                         <asp:Parameter Name="GotPhoneDetail" Type="String" />
                                         <asp:Parameter Name="GotAshelDetail" Type="String" />
                                         <asp:Parameter Name="AdvancedStudyDetail" Type="String" />
                                     </InsertParameters>
                                 </asp:ObjectDataSource>
                                 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                                     ConflictDetection="CompareAllValues" 
                                     ConnectionString="<%$ ConnectionStrings:Eden-DatabaseConnectionString3 %>" 
                                     DeleteCommand="DELETE FROM [EmpPersonalInfo] WHERE [EmpID] = @original_EmpID AND (([EmpName] = @original_EmpName) OR ([EmpName] IS NULL AND @original_EmpName IS NULL)) AND (([EmpFamily] = @original_EmpFamily) OR ([EmpFamily] IS NULL AND @original_EmpFamily IS NULL)) AND (([EmpAddress] = @original_EmpAddress) OR ([EmpAddress] IS NULL AND @original_EmpAddress IS NULL)) AND (([EmpGender] = @original_EmpGender) OR ([EmpGender] IS NULL AND @original_EmpGender IS NULL)) AND (([EmpMaritalStatus] = @original_EmpMaritalStatus) OR ([EmpMaritalStatus] IS NULL AND @original_EmpMaritalStatus IS NULL)) AND (([EmpBirthDate] = @original_EmpBirthDate) OR ([EmpBirthDate] IS NULL AND @original_EmpBirthDate IS NULL)) AND (([EmpWorkDate] = @original_EmpWorkDate) OR ([EmpWorkDate] IS NULL AND @original_EmpWorkDate IS NULL)) AND (([EmpWorkStatus] = @original_EmpWorkStatus) OR ([EmpWorkStatus] IS NULL AND @original_EmpWorkStatus IS NULL)) AND (([EmpWorkEndDate] = @original_EmpWorkEndDate) OR ([EmpWorkEndDate] IS NULL AND @original_EmpWorkEndDate IS NULL)) AND (([WorkMobile] = @original_WorkMobile) OR ([WorkMobile] IS NULL AND @original_WorkMobile IS NULL)) AND (([PersonalMobile] = @original_PersonalMobile) OR ([PersonalMobile] IS NULL AND @original_PersonalMobile IS NULL)) AND (([HomePhone] = @original_HomePhone) OR ([HomePhone] IS NULL AND @original_HomePhone IS NULL)) AND (([EmailAddress1] = @original_EmailAddress1) OR ([EmailAddress1] IS NULL AND @original_EmailAddress1 IS NULL)) AND (([EmailAddress2] = @original_EmailAddress2) OR ([EmailAddress2] IS NULL AND @original_EmailAddress2 IS NULL)) AND (([Projectkey] = @original_Projectkey) OR ([Projectkey] IS NULL AND @original_Projectkey IS NULL)) AND (([EmpWorkRol] = @original_EmpWorkRol) OR ([EmpWorkRol] IS NULL AND @original_EmpWorkRol IS NULL)) AND (([JobPercentage] = @original_JobPercentage) OR ([JobPercentage] IS NULL AND @original_JobPercentage IS NULL)) AND (([PoolHour] = @original_PoolHour) OR ([PoolHour] IS NULL AND @original_PoolHour IS NULL)) AND (([PoolHourType] = @original_PoolHourType) OR ([PoolHourType] IS NULL AND @original_PoolHourType IS NULL)) AND (([Wage] = @original_Wage) OR ([Wage] IS NULL AND @original_Wage IS NULL)) AND (([WageMethod] = @original_WageMethod) OR ([WageMethod] IS NULL AND @original_WageMethod IS NULL)) AND (([GotPhone] = @original_GotPhone) OR ([GotPhone] IS NULL AND @original_GotPhone IS NULL)) AND (([GotAshel] = @original_GotAshel) OR ([GotAshel] IS NULL AND @original_GotAshel IS NULL)) AND (([AdvancedStudy] = @original_AdvancedStudy) OR ([AdvancedStudy] IS NULL AND @original_AdvancedStudy IS NULL)) AND (([TravelPayment] = @original_TravelPayment) OR ([TravelPayment] IS NULL AND @original_TravelPayment IS NULL)) AND (([EmployeePension] = @original_EmployeePension) OR ([EmployeePension] IS NULL AND @original_EmployeePension IS NULL)) AND (([employerPension] = @original_employerPension) OR ([employerPension] IS NULL AND @original_employerPension IS NULL)) AND (([OffsetExemptions] = @original_OffsetExemptions) OR ([OffsetExemptions] IS NULL AND @original_OffsetExemptions IS NULL)) AND (([ProvidentFund] = @original_ProvidentFund) OR ([ProvidentFund] IS NULL AND @original_ProvidentFund IS NULL)) AND (([SubProj] = @original_SubProj) OR ([SubProj] IS NULL AND @original_SubProj IS NULL)) AND (([EmpChildNum] = @original_EmpChildNum) OR ([EmpChildNum] IS NULL AND @original_EmpChildNum IS NULL)) AND (([EmpWageContract] = @original_EmpWageContract) OR ([EmpWageContract] IS NULL AND @original_EmpWageContract IS NULL)) AND (([TravelMethodType] = @original_TravelMethodType) OR ([TravelMethodType] IS NULL AND @original_TravelMethodType IS NULL)) AND (([GotPhoneDetail] = @original_GotPhoneDetail) OR ([GotPhoneDetail] IS NULL AND @original_GotPhoneDetail IS NULL)) AND (([GotAshelDetail] = @original_GotAshelDetail) OR ([GotAshelDetail] IS NULL AND @original_GotAshelDetail IS NULL)) AND (([AdvancedStudyDetail] = @original_AdvancedStudyDetail) OR ([AdvancedStudyDetail] IS NULL AND @original_AdvancedStudyDetail IS NULL))" 
                                     InsertCommand="INSERT INTO [EmpPersonalInfo] ([EmpName], [EmpFamily], [EmpID], [EmpAddress], [EmpGender], [EmpMaritalStatus], [EmpBirthDate], [EmpWorkDate], [EmpWorkStatus], [EmpWorkEndDate], [WorkMobile], [PersonalMobile], [HomePhone], [EmailAddress1], [EmailAddress2], [Projectkey], [EmpWorkRol], [JobPercentage], [PoolHour], [PoolHourType], [Wage], [WageMethod], [GotPhone], [GotAshel], [AdvancedStudy], [TravelPayment], [EmployeePension], [employerPension], [OffsetExemptions], [ProvidentFund], [SubProj], [EmpChildNum], [EmpWageContract], [TravelMethodType], [GotPhoneDetail], [GotAshelDetail], [AdvancedStudyDetail]) VALUES (@EmpName, @EmpFamily, @EmpID, @EmpAddress, @EmpGender, @EmpMaritalStatus, @EmpBirthDate, @EmpWorkDate, @EmpWorkStatus, @EmpWorkEndDate, @WorkMobile, @PersonalMobile, @HomePhone, @EmailAddress1, @EmailAddress2, @Projectkey, @EmpWorkRol, @JobPercentage, @PoolHour, @PoolHourType, @Wage, @WageMethod, @GotPhone, @GotAshel, @AdvancedStudy, @TravelPayment, @EmployeePension, @employerPension, @OffsetExemptions, @ProvidentFund, @SubProj, @EmpChildNum, @EmpWageContract, @TravelMethodType, @GotPhoneDetail, @GotAshelDetail, @AdvancedStudyDetail)" 
                                     OldValuesParameterFormatString="original_{0}" 
                                     SelectCommand="SELECT * FROM [EmpPersonalInfo]" 
                                     UpdateCommand="UPDATE [EmpPersonalInfo] SET [EmpName] = @EmpName, [EmpFamily] = @EmpFamily, [EmpAddress] = @EmpAddress, [EmpGender] = @EmpGender, [EmpMaritalStatus] = @EmpMaritalStatus, [EmpBirthDate] = @EmpBirthDate, [EmpWorkDate] = @EmpWorkDate, [EmpWorkStatus] = @EmpWorkStatus, [EmpWorkEndDate] = @EmpWorkEndDate, [WorkMobile] = @WorkMobile, [PersonalMobile] = @PersonalMobile, [HomePhone] = @HomePhone, [EmailAddress1] = @EmailAddress1, [EmailAddress2] = @EmailAddress2, [Projectkey] = @Projectkey, [EmpWorkRol] = @EmpWorkRol, [JobPercentage] = @JobPercentage, [PoolHour] = @PoolHour, [PoolHourType] = @PoolHourType, [Wage] = @Wage, [WageMethod] = @WageMethod, [GotPhone] = @GotPhone, [GotAshel] = @GotAshel, [AdvancedStudy] = @AdvancedStudy, [TravelPayment] = @TravelPayment, [EmployeePension] = @EmployeePension, [employerPension] = @employerPension, [OffsetExemptions] = @OffsetExemptions, [ProvidentFund] = @ProvidentFund, [SubProj] = @SubProj, [EmpChildNum] = @EmpChildNum, [EmpWageContract] = @EmpWageContract, [TravelMethodType] = @TravelMethodType, [GotPhoneDetail] = @GotPhoneDetail, [GotAshelDetail] = @GotAshelDetail, [AdvancedStudyDetail] = @AdvancedStudyDetail WHERE [EmpID] = @original_EmpID AND (([EmpName] = @original_EmpName) OR ([EmpName] IS NULL AND @original_EmpName IS NULL)) AND (([EmpFamily] = @original_EmpFamily) OR ([EmpFamily] IS NULL AND @original_EmpFamily IS NULL)) AND (([EmpAddress] = @original_EmpAddress) OR ([EmpAddress] IS NULL AND @original_EmpAddress IS NULL)) AND (([EmpGender] = @original_EmpGender) OR ([EmpGender] IS NULL AND @original_EmpGender IS NULL)) AND (([EmpMaritalStatus] = @original_EmpMaritalStatus) OR ([EmpMaritalStatus] IS NULL AND @original_EmpMaritalStatus IS NULL)) AND (([EmpBirthDate] = @original_EmpBirthDate) OR ([EmpBirthDate] IS NULL AND @original_EmpBirthDate IS NULL)) AND (([EmpWorkDate] = @original_EmpWorkDate) OR ([EmpWorkDate] IS NULL AND @original_EmpWorkDate IS NULL)) AND (([EmpWorkStatus] = @original_EmpWorkStatus) OR ([EmpWorkStatus] IS NULL AND @original_EmpWorkStatus IS NULL)) AND (([EmpWorkEndDate] = @original_EmpWorkEndDate) OR ([EmpWorkEndDate] IS NULL AND @original_EmpWorkEndDate IS NULL)) AND (([WorkMobile] = @original_WorkMobile) OR ([WorkMobile] IS NULL AND @original_WorkMobile IS NULL)) AND (([PersonalMobile] = @original_PersonalMobile) OR ([PersonalMobile] IS NULL AND @original_PersonalMobile IS NULL)) AND (([HomePhone] = @original_HomePhone) OR ([HomePhone] IS NULL AND @original_HomePhone IS NULL)) AND (([EmailAddress1] = @original_EmailAddress1) OR ([EmailAddress1] IS NULL AND @original_EmailAddress1 IS NULL)) AND (([EmailAddress2] = @original_EmailAddress2) OR ([EmailAddress2] IS NULL AND @original_EmailAddress2 IS NULL)) AND (([Projectkey] = @original_Projectkey) OR ([Projectkey] IS NULL AND @original_Projectkey IS NULL)) AND (([EmpWorkRol] = @original_EmpWorkRol) OR ([EmpWorkRol] IS NULL AND @original_EmpWorkRol IS NULL)) AND (([JobPercentage] = @original_JobPercentage) OR ([JobPercentage] IS NULL AND @original_JobPercentage IS NULL)) AND (([PoolHour] = @original_PoolHour) OR ([PoolHour] IS NULL AND @original_PoolHour IS NULL)) AND (([PoolHourType] = @original_PoolHourType) OR ([PoolHourType] IS NULL AND @original_PoolHourType IS NULL)) AND (([Wage] = @original_Wage) OR ([Wage] IS NULL AND @original_Wage IS NULL)) AND (([WageMethod] = @original_WageMethod) OR ([WageMethod] IS NULL AND @original_WageMethod IS NULL)) AND (([GotPhone] = @original_GotPhone) OR ([GotPhone] IS NULL AND @original_GotPhone IS NULL)) AND (([GotAshel] = @original_GotAshel) OR ([GotAshel] IS NULL AND @original_GotAshel IS NULL)) AND (([AdvancedStudy] = @original_AdvancedStudy) OR ([AdvancedStudy] IS NULL AND @original_AdvancedStudy IS NULL)) AND (([TravelPayment] = @original_TravelPayment) OR ([TravelPayment] IS NULL AND @original_TravelPayment IS NULL)) AND (([EmployeePension] = @original_EmployeePension) OR ([EmployeePension] IS NULL AND @original_EmployeePension IS NULL)) AND (([employerPension] = @original_employerPension) OR ([employerPension] IS NULL AND @original_employerPension IS NULL)) AND (([OffsetExemptions] = @original_OffsetExemptions) OR ([OffsetExemptions] IS NULL AND @original_OffsetExemptions IS NULL)) AND (([ProvidentFund] = @original_ProvidentFund) OR ([ProvidentFund] IS NULL AND @original_ProvidentFund IS NULL)) AND (([SubProj] = @original_SubProj) OR ([SubProj] IS NULL AND @original_SubProj IS NULL)) AND (([EmpChildNum] = @original_EmpChildNum) OR ([EmpChildNum] IS NULL AND @original_EmpChildNum IS NULL)) AND (([EmpWageContract] = @original_EmpWageContract) OR ([EmpWageContract] IS NULL AND @original_EmpWageContract IS NULL)) AND (([TravelMethodType] = @original_TravelMethodType) OR ([TravelMethodType] IS NULL AND @original_TravelMethodType IS NULL)) AND (([GotPhoneDetail] = @original_GotPhoneDetail) OR ([GotPhoneDetail] IS NULL AND @original_GotPhoneDetail IS NULL)) AND (([GotAshelDetail] = @original_GotAshelDetail) OR ([GotAshelDetail] IS NULL AND @original_GotAshelDetail IS NULL)) AND (([AdvancedStudyDetail] = @original_AdvancedStudyDetail) OR ([AdvancedStudyDetail] IS NULL AND @original_AdvancedStudyDetail IS NULL))">
                                     <DeleteParameters>
                                         <asp:Parameter Name="original_EmpID" Type="String" />
                                         <asp:Parameter Name="original_EmpName" Type="String" />
                                         <asp:Parameter Name="original_EmpFamily" Type="String" />
                                         <asp:Parameter Name="original_EmpAddress" Type="String" />
                                         <asp:Parameter Name="original_EmpGender" Type="String" />
                                         <asp:Parameter Name="original_EmpMaritalStatus" Type="String" />
                                         <asp:Parameter DbType="Date" Name="original_EmpBirthDate" />
                                         <asp:Parameter DbType="Date" Name="original_EmpWorkDate" />
                                         <asp:Parameter Name="original_EmpWorkStatus" Type="String" />
                                         <asp:Parameter DbType="Date" Name="original_EmpWorkEndDate" />
                                         <asp:Parameter Name="original_WorkMobile" Type="String" />
                                         <asp:Parameter Name="original_PersonalMobile" Type="String" />
                                         <asp:Parameter Name="original_HomePhone" Type="String" />
                                         <asp:Parameter Name="original_EmailAddress1" Type="String" />
                                         <asp:Parameter Name="original_EmailAddress2" Type="String" />
                                         <asp:Parameter Name="original_Projectkey" Type="String" />
                                         <asp:Parameter Name="original_EmpWorkRol" Type="String" />
                                         <asp:Parameter Name="original_JobPercentage" Type="Int32" />
                                         <asp:Parameter Name="original_PoolHour" Type="Double" />
                                         <asp:Parameter Name="original_PoolHourType" Type="String" />
                                         <asp:Parameter Name="original_Wage" Type="Int32" />
                                         <asp:Parameter Name="original_WageMethod" Type="Int32" />
                                         <asp:Parameter Name="original_GotPhone" Type="Boolean" />
                                         <asp:Parameter Name="original_GotAshel" Type="Boolean" />
                                         <asp:Parameter Name="original_AdvancedStudy" Type="Boolean" />
                                         <asp:Parameter Name="original_TravelPayment" Type="Boolean" />
                                         <asp:Parameter Name="original_EmployeePension" Type="String" />
                                         <asp:Parameter Name="original_employerPension" Type="String" />
                                         <asp:Parameter Name="original_OffsetExemptions" Type="String" />
                                         <asp:Parameter Name="original_ProvidentFund" Type="String" />
                                         <asp:Parameter Name="original_SubProj" Type="String" />
                                         <asp:Parameter Name="original_EmpChildNum" Type="Int32" />
                                         <asp:Parameter Name="original_EmpWageContract" Type="String" />
                                         <asp:Parameter Name="original_TravelMethodType" Type="String" />
                                         <asp:Parameter Name="original_GotPhoneDetail" Type="String" />
                                         <asp:Parameter Name="original_GotAshelDetail" Type="String" />
                                         <asp:Parameter Name="original_AdvancedStudyDetail" Type="String" />
                                     </DeleteParameters>
                                     <UpdateParameters>
                                         <asp:Parameter Name="EmpName" Type="String" />
                                         <asp:Parameter Name="EmpFamily" Type="String" />
                                         <asp:Parameter Name="EmpAddress" Type="String" />
                                         <asp:Parameter Name="EmpGender" Type="String" />
                                         <asp:Parameter Name="EmpMaritalStatus" Type="String" />
                                         <asp:Parameter DbType="Date" Name="EmpBirthDate" />
                                         <asp:Parameter DbType="Date" Name="EmpWorkDate" />
                                         <asp:Parameter Name="EmpWorkStatus" Type="String" />
                                         <asp:Parameter DbType="Date" Name="EmpWorkEndDate" />
                                         <asp:Parameter Name="WorkMobile" Type="String" />
                                         <asp:Parameter Name="PersonalMobile" Type="String" />
                                         <asp:Parameter Name="HomePhone" Type="String" />
                                         <asp:Parameter Name="EmailAddress1" Type="String" />
                                         <asp:Parameter Name="EmailAddress2" Type="String" />
                                         <asp:Parameter Name="Projectkey" Type="String" />
                                         <asp:Parameter Name="EmpWorkRol" Type="String" />
                                         <asp:Parameter Name="JobPercentage" Type="Int32" />
                                         <asp:Parameter Name="PoolHour" Type="Double" />
                                         <asp:Parameter Name="PoolHourType" Type="String" />
                                         <asp:Parameter Name="Wage" Type="Int32" />
                                         <asp:Parameter Name="WageMethod" Type="Int32" />
                                         <asp:Parameter Name="GotPhone" Type="Boolean" />
                                         <asp:Parameter Name="GotAshel" Type="Boolean" />
                                         <asp:Parameter Name="AdvancedStudy" Type="Boolean" />
                                         <asp:Parameter Name="TravelPayment" Type="Boolean" />
                                         <asp:Parameter Name="EmployeePension" Type="String" />
                                         <asp:Parameter Name="employerPension" Type="String" />
                                         <asp:Parameter Name="OffsetExemptions" Type="String" />
                                         <asp:Parameter Name="ProvidentFund" Type="String" />
                                         <asp:Parameter Name="SubProj" Type="String" />
                                         <asp:Parameter Name="EmpChildNum" Type="Int32" />
                                         <asp:Parameter Name="EmpWageContract" Type="String" />
                                         <asp:Parameter Name="TravelMethodType" Type="String" />
                                         <asp:Parameter Name="GotPhoneDetail" Type="String" />
                                         <asp:Parameter Name="GotAshelDetail" Type="String" />
                                         <asp:Parameter Name="AdvancedStudyDetail" Type="String" />
                                         <asp:Parameter Name="original_EmpID" Type="String" />
                                         <asp:Parameter Name="original_EmpName" Type="String" />
                                         <asp:Parameter Name="original_EmpFamily" Type="String" />
                                         <asp:Parameter Name="original_EmpAddress" Type="String" />
                                         <asp:Parameter Name="original_EmpGender" Type="String" />
                                         <asp:Parameter Name="original_EmpMaritalStatus" Type="String" />
                                         <asp:Parameter DbType="Date" Name="original_EmpBirthDate" />
                                         <asp:Parameter DbType="Date" Name="original_EmpWorkDate" />
                                         <asp:Parameter Name="original_EmpWorkStatus" Type="String" />
                                         <asp:Parameter DbType="Date" Name="original_EmpWorkEndDate" />
                                         <asp:Parameter Name="original_WorkMobile" Type="String" />
                                         <asp:Parameter Name="original_PersonalMobile" Type="String" />
                                         <asp:Parameter Name="original_HomePhone" Type="String" />
                                         <asp:Parameter Name="original_EmailAddress1" Type="String" />
                                         <asp:Parameter Name="original_EmailAddress2" Type="String" />
                                         <asp:Parameter Name="original_Projectkey" Type="String" />
                                         <asp:Parameter Name="original_EmpWorkRol" Type="String" />
                                         <asp:Parameter Name="original_JobPercentage" Type="Int32" />
                                         <asp:Parameter Name="original_PoolHour" Type="Double" />
                                         <asp:Parameter Name="original_PoolHourType" Type="String" />
                                         <asp:Parameter Name="original_Wage" Type="Int32" />
                                         <asp:Parameter Name="original_WageMethod" Type="Int32" />
                                         <asp:Parameter Name="original_GotPhone" Type="Boolean" />
                                         <asp:Parameter Name="original_GotAshel" Type="Boolean" />
                                         <asp:Parameter Name="original_AdvancedStudy" Type="Boolean" />
                                         <asp:Parameter Name="original_TravelPayment" Type="Boolean" />
                                         <asp:Parameter Name="original_EmployeePension" Type="String" />
                                         <asp:Parameter Name="original_employerPension" Type="String" />
                                         <asp:Parameter Name="original_OffsetExemptions" Type="String" />
                                         <asp:Parameter Name="original_ProvidentFund" Type="String" />
                                         <asp:Parameter Name="original_SubProj" Type="String" />
                                         <asp:Parameter Name="original_EmpChildNum" Type="Int32" />
                                         <asp:Parameter Name="original_EmpWageContract" Type="String" />
                                         <asp:Parameter Name="original_TravelMethodType" Type="String" />
                                         <asp:Parameter Name="original_GotPhoneDetail" Type="String" />
                                         <asp:Parameter Name="original_GotAshelDetail" Type="String" />
                                         <asp:Parameter Name="original_AdvancedStudyDetail" Type="String" />
                                     </UpdateParameters>
                                     <InsertParameters>
                                         <asp:Parameter Name="EmpName" Type="String" />
                                         <asp:Parameter Name="EmpFamily" Type="String" />
                                         <asp:Parameter Name="EmpID" Type="String" />
                                         <asp:Parameter Name="EmpAddress" Type="String" />
                                         <asp:Parameter Name="EmpGender" Type="String" />
                                         <asp:Parameter Name="EmpMaritalStatus" Type="String" />
                                         <asp:Parameter Name="EmpBirthDate" Type="String" />
                                         <asp:Parameter Name="EmpWorkDate" Type="String"  />
                                         <asp:Parameter Name="EmpWorkStatus" Type="String" />
                                         <asp:Parameter Name="EmpWorkEndDate" Type="String"  />
                                         <asp:Parameter Name="WorkMobile" Type="String" />
                                         <asp:Parameter Name="PersonalMobile" Type="String" />
                                         <asp:Parameter Name="HomePhone" Type="String" />
                                         <asp:Parameter Name="EmailAddress1" Type="String" />
                                         <asp:Parameter Name="EmailAddress2" Type="String" />
                                         <asp:Parameter Name="Projectkey" Type="String" />
                                         <asp:Parameter Name="EmpWorkRol" Type="String" />
                                         <asp:Parameter Name="JobPercentage" Type="Int32" />
                                         <asp:Parameter Name="PoolHour" Type="Double" />
                                         <asp:Parameter Name="PoolHourType" Type="String" />
                                         <asp:Parameter Name="Wage" Type="Int32" />
                                         <asp:Parameter Name="WageMethod" Type="Int32" />
                                         <asp:Parameter Name="GotPhone" Type="Boolean" />
                                         <asp:Parameter Name="GotAshel" Type="Boolean" />
                                         <asp:Parameter Name="AdvancedStudy" Type="Boolean" />
                                         <asp:Parameter Name="TravelPayment" Type="Boolean" />
                                         <asp:Parameter Name="EmployeePension" Type="String" />
                                         <asp:Parameter Name="employerPension" Type="String" />
                                         <asp:Parameter Name="OffsetExemptions" Type="String" />
                                         <asp:Parameter Name="ProvidentFund" Type="String" />
                                         <asp:Parameter Name="SubProj" Type="String" />
                                         <asp:Parameter Name="EmpChildNum" Type="Int32" />
                                         <asp:Parameter Name="EmpWageContract" Type="String" />
                                         <asp:Parameter Name="TravelMethodType" Type="String" />
                                         <asp:Parameter Name="GotPhoneDetail" Type="String" />
                                         <asp:Parameter Name="GotAshelDetail" Type="String" />
                                         <asp:Parameter Name="AdvancedStudyDetail" Type="String" />
                                     </InsertParameters>
                                 </asp:SqlDataSource>
    </div>
</div>

</asp:Content>
